package cn.iocoder.yudao.module.book.dal.mysql;

import java.util.List;

import cn.iocoder.yudao.module.book.controller.app.vo.BookSchoolAssignmentListVO;
import cn.iocoder.yudao.module.book.dal.dataobject.BookClassManagementMemberDO;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import cn.iocoder.yudao.framework.mybatis.core.mapper.BaseMapperX;

@Mapper
public interface BookClassManagementMemberMapper extends BaseMapperX<BookClassManagementMemberDO> {


    @Select("SELECT bcmm.id,bcmm.member_id,su.nickname FROM\tbook_class_management_member AS bcmm \n" +
            "\tLEFT JOIN system_users AS su ON su.id = bcmm.member_id where bcmm.class_management_id = #{classManagementId}")
    List<BookSchoolAssignmentListVO> selectListByClassManagementId(@Param("classManagementId") Long classManagementId);

}